DROP TABLE IF EXISTS jms_dim.dim_lmdm_sys_tail_code_staff;
CREATE EXTERNAL TABLE jms_dim.dim_lmdm_sys_tail_code_staff(
 ID bigint comment "ID",  --NUMBER(11)
 TAIL_CODE string comment "单元区域编码（关联字段）",  --VARCHAR2(20)
 TAIL_ID bigint comment "单元区域ID（关联字段）",  --NUMBER(11)
 STAFF_ID bigint comment "业务员ID",  --NUMBER(11)
 STAFF_CODE string comment "业务员编码",  --VARCHAR2(20)
 STAFF_NAME string comment "业务员名称"  --VARCHAR2(60)
 )
 COMMENT '运单变化记录维表'
 STORED AS PARQUET
 LOCATION '/dw/hive/jms_dim.db/external/dim_lmdm_sys_tail_code_staff'
 TBLPROPERTIES (
 'discover.partitions'='false',
 'parquet.column.index.access'='true'
 );